AWS Redshift administrator Engineer
Interview : Boston, MA (Onsite)
Job Duties:
- Administer and maintain scalable cloud environments and applications for data organization. Understanding business objectives of the company and creating cloud-based solutions to facilitate those objectives.
- Implement Infrastructure as Code and deploy code using Terraform, Gitlab Install and maintain software, services, and application by identifying system requirements.
- Hands-on AWS Services and DB and Server troubleshooting experience.
- Extensive database experience with RDS, AWS Redshift, MySQL
- Maintains environment by identifying system requirements, installing upgrades and monitoring system performance.
- Knowledge of day-to-day database operations, deployments, and development
- Experienced in Snowflake
- Knowledge of SQL and Performance tuning
- Knowledge of Linux Shell Scripting or Python
- Migrate system from one AWS cloud to another AWS account
- Hands-on DB and Server troubleshooting experience
- Maintains system performance by performing system monitoring and analysis and performance tuning.
- Troubleshooting system hardware, software, and operating and system management systems. Secures web system by developing system access, monitoring, control, and evaluation.
- Testing disaster recovery policies and procedures; completing back-ups; and maintaining documentation.
- Upgrades system and services and developing, testing, evaluating, and installing enhancements and new software.
- Communicating with internal teams, like EIMO, Operations, and Cloud Architect
- Communicate with stakeholders and build applications to meet project needs.
Minimum Skills Required:
- Bachelor s degree in computer science or engineering
- Minimum of 12 years of experience in System, platform, and AWS cloud administration
- Minimum of 5 to 8 years of Database administration and AWS experience using latest AWS technologies AWS EC2, Redshift, VPC, S3, AWS RDS Experience with Java, Python, Redshift, MySQL, or equivalent database tools
- Experience with Agile software development using JIRA
- Experience in multiple OS platforms with strong emphasis on Linux and Windows systems Experience with OS-level scripting environment such as KSH shell., PowerShell
- Experience with version management tools and CICD pipeline
- In-depth knowledge of the TCP / IP protocol suite, security architecture, securing and hardening Operating Systems, Networks, Databases and Applications.
- Advanced SQL knowledge and experience working with relational databases, query authoring (SQL) , query performance tuning.
- Experience supporting and optimizing data pipelines and data sets.
- Knowledge of the Incident Response life cycle AWS solution architect certifications.
- Strong written and verbal communication skills.
